<?php
namespace app\admin\controller;

use \think\Controller;
use think\Db;
use think\facade\Request;
class Manager extends  Controller
{
	public function index()
	{
		$managers = Db::table('shop_manager')
		->alias('a')
		->field('a.id as id,nickname,phone,email,create_time,freeze,shop_role_id')
		->join('shop_manager_role','a.id=shop_manager_role.shop_manager_id','left')
		->join('shop_manager_detail','a.id=shop_manager_detail.manager_id','left')
		->select();
//		dump($managers);exit;
//		die;
		$this->assign('managers',$managers);
		
		return $this->fetch();
	}
}
